SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043542 LIMIT 1 [ RunTime:0.002775s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043542 [ RunTime:0.003628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184351,986839,246168,893607,837879,222599,67593,186161,331417,961293,767921,893772,629277,128800,216125,313586,860689,462716,790851,498751,91034,792557,396739,253077,581578,952798,152008,674024,596873,141012,80945,84516,961861,107990,793378,857922,461321,666266,97305,1047781,272529,1011286,345390,211177,334305,716172,672714,579787,117797,20579,694315,620729,520065,877267,483910,960749,990624,391430,107667,449510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]