SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 709282 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 709282 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002148,107698,539535,642869,430409,511651,469010,333936,20122,588964,27383,396268,617200,27687,830266,332863,702941,871251,100125,808636,664661,537671,4973,825236,169405,700338,474605,477371,407392,328253,179959,829484,1017228,256179,372840,954556,71621,371427,360668,722645,296158,188001,473592,796104,515066,306658,487373,731834,932713,322905,708707,179841,315230,274852,218200,360598,933336,811083,43473,957707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 709282 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 709282 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]