SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691900 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691900 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732105,884853,1048718,496737,731730,260988,286778,811443,980580,334032,349932,556475,140351,444564,268865,206180,260466,32607,598710,487230,106953,329949,755157,695093,594238,1041347,541255,685627,345152,159124,269748,48060,148392,278841,771268,850897,290369,672933,762022,761874,79171,68407,416628,555532,605496,409934,258943,890060,854746,939498,498046,856806,646923,770478,848424,528822,586046,14009,489105,334325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]