SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579258 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579258 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202516,717672,597854,115936,12821,271365,103057,718176,781452,243545,257886,1043932,551846,1048055,930143,70310,904540,1019547,1025801,79647,863024,209876,503648,993318,723581,103493,751332,527497,39110,412502,127126,958892,509488,103048,1035057,928851,466634,270339,603375,341443,807971,1047783,885954,42946,271015,908887,672771,954402,974709,964653,899812,1004882,456129,55966,411465,731980,416187,2302,869722,705132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]