SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501781 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501781 [ RunTime:0.002785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562647,632479,108201,145695,939435,870785,536449,69374,541607,809035,29711,578646,162067,257495,654560,318050,315291,462141,315229,927195,99049,545621,374651,484888,1042375,399740,170593,63272,650092,272255,296978,563503,379419,799834,157622,1014082,428891,522347,846702,384099,200306,791778,50655,172600,832208,1001489,628899,824943,93659,944734,584990,770530,33399,343807,4366,725665,884242,962822,508547,542376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]