SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305460 LIMIT 1 [ RunTime:0.000670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305460 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936517,434426,462816,204079,472080,790571,353841,663572,690095,852398,16581,503451,974327,645739,297639,293084,404035,716620,588215,447136,721538,439168,74752,481450,1020344,469148,383970,153764,333691,607036,382206,429709,115023,911641,17050,817551,12287,577965,840772,855811,312985,749667,768740,412460,243198,539756,299208,887340,511645,1012181,834157,690648,804186,652796,292989,497937,781205,232368,666732,52885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]