SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555727 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555727 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385093,977907,736950,976878,526478,119588,529957,576764,268101,473689,170660,1018375,135640,275527,522995,465819,136864,237904,742341,429272,1022235,605960,219167,913693,594704,911216,52418,303843,364026,210096,332099,810898,698644,22608,92008,410652,205654,387462,323366,353418,425176,58475,174084,600834,93871,531055,805196,640546,637118,907255,879112,666499,663977,18704,128891,1039608,333549,918050,391995,849021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555727 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555727 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002391s ]