SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300914 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300914 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010014,510721,898505,639492,843351,808061,897748,103233,615076,462241,857851,249178,465583,767498,186040,186113,278821,824323,772711,61158,299595,990818,47715,627945,118379,304752,833624,191626,585766,295929,270245,216918,249667,117231,167678,868906,41124,427240,409407,95840,573461,778195,1031464,331469,717454,69227,48604,112202,407447,965163,775426,791063,244257,963276,325683,425213,274595,101695,34810,638335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]