SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 170418 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 170418 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182812,8281,470896,18622,856030,982466,1013352,385324,172161,645334,44727,575286,375280,581719,818758,694271,582066,447968,885983,21454,351996,182528,840210,901683,247039,962510,671801,661292,208926,266510,850096,505246,179105,45459,46988,949190,370263,440319,707006,519384,436724,903995,398617,140786,914182,169067,936879,892930,219036,897674,595866,923595,347609,394779,315021,64080,460359,611982,777347,15161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 170418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 170418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]