SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34436 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34436 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279979,437660,772006,661279,586869,280014,393777,761394,630871,317315,560415,41964,745223,883147,925736,555707,40296,526858,543604,379609,143739,53243,734185,453583,716727,983923,192050,654516,409241,798016,88755,80125,469015,940319,511284,648312,660771,409804,661444,1033342,963093,716354,123609,332614,465189,464228,725717,1016940,709278,448704,578569,550129,1038685,625900,160405,348632,227146,130482,155794,436179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]