SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314151 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314151 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372207,3743,630137,448354,684959,599180,1013578,259817,893573,703795,335179,857427,260209,354884,533576,606417,488439,371045,444595,118146,219943,591634,448824,791036,781901,392324,73726,800452,652740,1040612,575201,443904,992534,398661,866821,726284,467369,7970,904035,641641,635061,188286,521543,585251,365586,324640,974503,505911,895277,678075,674095,377195,519707,146732,635567,696579,941322,12992,373037,170496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]