SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810679 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810679 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332955,22934,362366,686567,896573,624343,194839,724460,136679,1040574,466094,137987,753425,949203,270625,440374,868853,954723,538560,1047544,764951,867191,331,757228,505447,157529,811881,108240,971052,1046908,170579,261090,252842,935079,131498,627110,453003,398567,134462,501796,223726,267597,120883,705749,511854,201908,579772,222575,431255,165805,462221,981939,715341,701756,208011,33919,588624,62732,492995,963675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001507s ]