SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019912 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019912 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789361,785564,360612,266144,237100,402638,531721,671761,402384,942870,412491,1010878,710534,1012903,774029,362875,279372,306141,627175,228383,11175,479862,864170,446494,473964,124644,649403,718336,904121,382565,528051,1025446,577818,467958,761580,694452,778730,876399,720571,677855,16029,367623,517753,147285,647139,283419,886638,213506,562022,646425,583840,494932,967666,190748,678772,488721,918153,311918,675293,560286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000868s ]