SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106509 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106509 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691821,772179,1005625,1019049,976246,61017,590933,764939,735781,12072,661490,860525,664681,368892,997027,73985,520267,516407,627397,744322,448951,848484,139175,497613,22772,255464,366648,839976,293053,697309,375978,511247,706299,584765,469888,697405,156526,14981,12053,460586,682401,230531,602966,327333,690032,236974,358323,988623,464354,417725,14743,263556,394567,432017,564998,1019064,733756,681580,780372,473664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002231s ]