SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488413 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488413 [ RunTime:0.004528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945446,724452,505556,610006,363598,345754,748968,890564,839284,775861,769143,783127,723837,245045,971170,135527,274997,478014,247696,158570,313895,326225,676544,249461,270662,770037,499811,966667,159255,415110,913776,592863,651666,1033845,11908,662316,209002,318937,107142,797085,973359,258042,709481,18817,679627,88631,603261,420945,13011,958784,738467,579772,878704,31543,834229,424976,1017784,156241,1006303,834898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]