SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 206686 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206686 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518073,132810,311369,982971,468684,876533,567056,889077,706500,128708,893345,451617,105041,295193,220087,759525,45418,1014343,855888,295237,365981,1020431,687965,314560,146339,534930,497756,498183,213569,839337,1042776,106137,856981,732433,321037,881582,162341,972998,824856,519758,379329,171539,962757,1047907,534016,782443,645624,926139,111962,51489,636993,205571,60476,36606,185242,541313,276337,491808,29539,1032818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]