SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012203 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012203 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786073,165465,269480,329703,900098,498697,1008248,327636,512942,675800,225510,1024107,265403,393455,602908,435325,837611,503826,834171,973008,362670,1037189,405788,992986,944118,714977,926957,354510,702514,107516,181786,1011334,620951,396805,203971,711854,656453,861050,479838,712777,339506,107804,480208,244569,356352,751954,91732,678539,366133,421726,414104,539751,850639,115016,356749,37009,1023067,610176,422426,154548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]