SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241210 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241210 [ RunTime:0.006815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889449,321381,340121,741750,676733,509404,399457,233407,334848,930502,787014,956103,482868,49238,920546,100142,118247,804365,522258,733616,71216,255537,685575,15284,685769,408339,743596,488252,916622,371942,247006,392568,776989,9643,54600,530896,1028901,409341,565616,623221,1014696,936281,145028,14857,589025,277307,336385,553100,441510,556009,361464,98857,467052,298884,5747,572129,550674,48605,85375,200879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]