SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497804 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497804 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590483,275614,377908,917617,142218,1017294,879131,100972,673290,737485,596940,991082,692867,167712,628305,385754,168407,849253,1034160,127451,392331,158224,666553,113666,94868,347045,644290,749398,616746,1028416,459430,701385,1035573,1037727,645749,606684,98870,918772,604149,561067,405536,1037598,1002442,504883,563600,827221,40497,492291,447020,83504,207793,393012,512842,14782,270224,627785,526582,547001,197388,901686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]