SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475716 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475716 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656180,391745,164754,193907,803626,641261,737466,104965,818673,194974,761639,446821,881070,94922,293897,72902,321337,273370,730223,978510,1033553,394482,614252,568944,60148,823087,1036074,1015671,20036,790194,526201,711278,148000,139071,874925,290754,250876,668137,379507,1038217,1043861,22833,933761,833292,89938,966781,69639,164474,220148,859454,81042,347181,820477,509192,583727,433955,524472,854062,972336,597326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000749s ]