SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201211 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201211 [ RunTime:0.003849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923705,504607,775103,138942,751929,621179,873493,265465,1017936,558352,456,1035836,887741,158095,355899,12943,932055,968049,411505,658822,354730,1022967,1030786,312398,532159,600661,277000,829363,466016,371089,340602,371361,747924,314400,828500,832586,637406,747955,276440,410742,603801,224921,39518,113580,918520,482140,160576,79714,197534,268067,252172,969212,632485,307794,563142,981718,234515,1032563,926691,847132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]