SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004142 LIMIT 1 [ RunTime:0.005698s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004142 [ RunTime:0.004867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181146,937862,396834,803252,258023,459403,236969,236155,843805,584122,326912,326720,899768,962033,471806,43166,228840,951953,220895,463746,702887,57837,382128,27243,175550,84882,412652,393565,240958,175993,292980,974167,481186,606292,618080,690352,91898,32581,942267,188143,152667,116178,617458,77815,466768,149059,164792,869174,911816,719811,243471,916900,1018283,624131,160718,433814,569833,972172,23435,451236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]