SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42533 LIMIT 1 [ RunTime:0.000909s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42533 [ RunTime:0.002578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505026,736080,150452,34530,73272,741008,618796,138878,91596,433398,368364,507425,993579,898663,165788,6331,255766,25639,604150,763788,750738,17510,598067,828941,1010782,253652,121,667000,526482,89542,172503,833773,165203,11007,751109,960235,536628,890303,842674,297698,885682,1037034,90337,352731,654017,864719,416488,14171,704991,1022085,664952,89425,3733,116407,1033551,73876,685863,1004280,132940,806155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]