SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001795s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53589 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53589 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507975,174000,793746,641754,16026,987971,122407,1019596,633857,42274,699900,570569,200677,648150,190126,857348,969904,23304,262152,500962,1012127,415830,238497,492745,28396,673415,302023,344830,242799,87553,384370,829904,744663,902316,882726,752102,796926,692521,476401,430178,1028552,660877,776040,377675,65012,46916,635195,268641,625260,411206,90384,179013,224096,1048473,136121,959840,636210,787149,378301,778796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]