SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467591 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467591 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710177,252230,145618,88735,139515,284146,672887,619816,516770,160361,336896,366084,287747,118605,68831,202272,785565,517922,964954,1041051,184413,801943,644193,376314,437521,745991,459913,835478,820648,849870,730500,835638,696117,88251,496455,836635,468438,28749,653647,445331,327887,357113,64948,958726,968284,524806,263393,136485,18369,626029,933993,321310,537462,296102,805626,1004745,290471,1033816,385454,425942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]