SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533923 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533923 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107182,947946,295159,66499,59579,334385,46380,978620,1014214,118044,882221,879685,874388,384619,123929,236069,36318,276999,303229,141041,1020790,678963,523017,1004252,415442,28396,525627,874280,732713,286077,713871,182877,880733,426704,272329,719789,728501,409289,915289,420412,39665,450134,436855,101912,724409,556542,265491,861217,277589,1022051,916089,598981,1015225,558598,739702,379530,927201,879157,833338,563122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]