SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541715 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541715 [ RunTime:0.003155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609439,813627,1016936,987609,253571,362258,542908,119825,335788,13767,1012280,521517,288710,72284,1014517,588313,617868,626824,899873,764223,166019,624899,691327,159177,203639,748080,814870,734275,16069,607777,358936,117178,119568,438420,980794,389720,339393,645895,284890,443720,907964,1020935,756766,302864,317379,697417,819528,272668,983449,326686,1010025,285730,960786,591146,577276,652395,90306,444248,716355,323929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]