SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501905 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501905 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70113,532476,666955,1001618,573708,822717,51531,1038328,627815,294736,7250,796811,201900,100709,537127,142090,785109,122557,401169,914833,47941,280130,996068,218171,101753,491035,772381,1045943,600471,229988,982448,390371,484444,243372,723145,886816,106235,858789,998114,1007280,167105,532338,236734,260758,186035,1033182,585257,227589,963885,809678,584287,290160,466968,27316,1046388,106491,554264,671114,396312,789109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001200s ]