SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474470 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474470 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021571,944662,131335,839091,1038905,442921,948878,464277,689680,179650,228773,384762,686756,689764,55797,254183,580456,377875,442016,608189,125268,13846,120952,739169,834517,840556,402733,973383,360185,380824,890004,376768,124338,826048,480444,622965,422577,133714,892460,238833,886435,855474,400531,755497,493715,558332,773986,908570,594670,209197,330929,827063,557938,507625,43460,178300,760870,217923,484913,128784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]