SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 915001 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 915001 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942620,74058,460719,185998,631799,980561,657994,384706,275597,896527,249135,425634,121905,702046,417697,232433,1608,670666,956307,556208,791460,994433,184489,53598,915638,920763,832494,1017947,894850,612485,944576,228506,89945,139114,634796,396700,716107,19202,822071,236407,179366,482300,875795,642328,4830,196561,960144,222218,282430,864391,66126,976054,82637,96527,182364,46211,342277,296222,403793,385300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 915001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 915001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]