SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 158928 LIMIT 1 [ RunTime:0.001749s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 158928 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410123,308478,580777,774956,105241,165154,873600,252413,249320,117715,376490,757917,975506,490908,39075,148909,1019568,101796,1001811,896231,1023047,347224,412369,321770,908127,227350,258500,13262,460638,225514,512536,416210,139506,136851,286028,320486,242396,745822,142236,401181,203918,327675,419280,278374,109534,9326,895041,598087,626114,840462,388150,292003,266460,291565,828739,160019,411961,224392,820201,838471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 158928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 158928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001010s ]