SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405811 LIMIT 1 [ RunTime:0.000575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405811 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60323,482953,30322,359687,304663,570298,542066,427529,642107,1012559,858828,961695,363250,208932,478871,874068,842840,991360,735713,567623,873314,392726,453694,347134,299272,503455,567806,293948,948257,143576,730217,260740,654175,738261,854074,404527,118321,197154,301453,250675,326969,632551,828807,192254,103563,177818,721171,460458,616440,2799,609397,863851,785285,249883,71879,929284,119041,285551,249037,848150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]