SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020225 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020225 [ RunTime:0.002888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556080,1046092,314890,307869,873832,408926,1006600,314030,1005910,732686,233327,600395,688048,162693,274192,818874,956717,650290,858058,944078,621937,62413,752286,377743,1038797,561049,927249,1028535,985650,271008,55847,568031,720204,450838,294011,480785,68058,165689,936792,734676,711394,478889,327101,995752,390217,737568,170601,487836,505911,476758,743002,149930,717354,793948,819073,950190,604234,60794,165566,948383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020225 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020225 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]