SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671690 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671690 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300598,872855,12429,92562,192261,510748,367923,613587,753058,1019874,751223,172769,718115,121284,259919,460850,936253,296267,755758,193649,621637,409848,630770,232087,477900,223061,53657,361915,240476,480007,878183,987807,157010,182812,267479,795610,817387,547026,316717,488278,573393,344267,478777,308530,283975,454190,1009864,478185,835091,942601,139052,840871,730731,923253,733982,809832,417149,170425,382168,452672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]