SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014530 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014530 [ RunTime:0.008153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506785,559080,621640,78388,983849,15818,299431,95766,616240,876087,562106,34347,335398,922588,7545,365270,993359,361387,159758,286959,593561,444011,425638,851868,242203,1036124,874725,417105,76458,290939,215090,472316,855434,259863,461441,546773,898577,241500,993317,907734,983521,803078,56714,919698,342143,36868,91206,1008064,161330,829623,787334,239420,219854,297035,850745,214571,180436,344121,550964,30900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.039177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]