SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 153214 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 153214 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714443,611315,934591,232457,441872,888371,354626,104730,899309,195814,625028,879905,680424,804191,257473,485753,54722,695711,456867,497919,39822,136849,1128,901162,232318,800980,988106,77476,360892,81838,361260,77115,1014405,872417,206396,443446,914336,41963,850917,75481,870651,851116,602813,613409,553400,155030,220512,847589,632540,61278,952801,547367,791039,500736,598716,895626,753109,604358,193712,974253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 153214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 153214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]