SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 119495 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 119495 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35322,1027196,111052,188700,438636,548440,1028655,356997,1007614,864860,506624,450837,1048115,305250,778880,744460,945419,81277,1027735,269393,211515,743713,253977,471033,869833,901563,803735,351002,953116,253330,437431,962011,380382,143445,683178,673977,851311,712092,577895,990763,266191,64887,905960,984188,253553,1009916,576902,785760,754811,840081,81752,391204,737441,222050,318135,310453,108390,811169,867136,351213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 119495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 119495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]