SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331581 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331581 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261193,845032,683129,38636,392090,177196,307335,886007,925847,45897,779641,647308,614847,206524,911229,425593,1458,775336,634285,121812,160242,136953,374129,258360,649686,563935,505966,563254,674270,227626,630732,98289,192081,99418,446389,274051,417938,145770,5800,301054,173312,359887,451191,296555,447717,284731,684596,1031001,813303,577968,86248,787008,618694,1011451,192534,147280,711030,131649,27113,462865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]