SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 65159 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 65159 [ RunTime:0.002410s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603907,489702,1011210,1036312,255715,111299,839685,302114,839907,593548,542446,895527,370720,279965,278783,896526,249630,220568,563676,516515,921464,33998,4754,679733,338177,980263,920224,445887,843564,581008,447074,640575,47770,420185,609107,892971,663685,254110,1013521,508607,508580,219113,92598,177435,1010124,848613,785025,899015,60729,923348,966475,439026,476311,234778,819044,498045,673752,509354,10809,618540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 65159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 65159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001464s ]