SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397103 LIMIT 1 [ RunTime:0.001149s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397103 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448122,454647,349435,832106,977027,291739,768218,866625,664255,208907,514500,299389,341998,323350,741754,938306,662291,1027667,891759,202710,70258,746169,386378,470600,173227,821194,603421,219725,105341,396773,398875,646882,961987,553317,915422,461286,602477,502813,195398,109961,392261,311950,1010106,798590,285346,743933,704563,372431,750385,486862,215694,663099,158793,336788,53397,127458,531682,683361,657433,924028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]