SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501953 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501953 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196882,1042700,313119,69250,163638,154069,56424,355795,508416,68946,361218,824409,1041731,380894,111168,85718,678264,927438,794859,683217,210241,44611,524602,1001625,497524,890857,234979,540665,42476,723086,566647,552626,145573,741939,348630,881669,835371,202373,351923,735789,359829,525367,450490,62327,262352,734732,916624,1010721,537753,196238,502934,33867,396923,1008649,223623,301572,163740,643669,86930,857403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]