SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001841s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521447 LIMIT 1 [ RunTime:0.001505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521447 [ RunTime:0.002879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121591,112467,119351,807065,392031,124862,723292,359146,13667,255930,37224,485318,116087,673035,631439,767056,446372,880073,289212,233395,556825,200670,72939,187310,742956,321216,205211,467672,142617,691840,935016,651448,1002363,402256,861424,120711,142964,1023114,670555,409874,439607,180548,528744,878953,66148,385001,670039,282,957717,166217,735083,578146,19860,304887,713349,352367,304622,59636,725566,21700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]