SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44304 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44304 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20769,491326,282165,13644,378556,105108,374930,242037,962141,524468,166677,604571,34765,868347,312331,389891,516721,157283,368813,629618,877136,148456,270964,974391,93265,406933,454904,220591,72933,864515,154683,1018786,869752,882372,267956,425700,299565,663721,812773,749544,669272,437194,158553,545548,542382,588546,563780,639819,221212,174664,306004,911870,332310,342612,282028,417521,715711,959892,2870,201597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]