SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040591 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040591 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573784,810022,636144,1040180,1021685,1036257,439282,692917,371398,1038985,839485,167697,395662,140463,685247,752673,430021,69571,771071,264857,533680,207645,261287,483977,144636,993613,73868,469239,332406,841253,166691,210266,22323,780849,25507,478373,834606,859626,1016082,693277,836366,148397,445423,44897,706944,330946,685055,50161,89064,586339,425545,899304,209673,198003,996922,508234,850723,207004,926344,854363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]