SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450126 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450126 [ RunTime:0.003478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044149,618637,701035,39249,208351,205897,110063,232054,855383,928123,715202,797441,307950,987501,40132,207801,1040646,857253,137340,71752,444545,99340,759419,917129,280064,703818,779829,92180,247812,221829,752705,689697,870664,238634,851274,580415,156345,338234,699578,830881,338795,378263,999200,382106,703219,414698,369703,731258,883143,963541,727477,245006,571808,135408,776070,797800,23806,465687,202033,751354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]