SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473975 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473975 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027351,179446,390109,830453,366382,1015774,184229,473981,871901,908640,482654,276534,944914,708951,808198,764100,25587,569619,966114,536514,1004530,448227,217721,958752,36952,266830,637993,716103,103631,309967,611371,143432,442258,186703,959503,76718,1018380,72250,142606,1048551,431351,303337,428869,208317,57349,1044251,276450,980112,196557,35990,870812,14706,354152,182136,272619,460388,878181,662672,470306,708182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]