SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047981 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047981 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701468,482619,98798,166002,720871,843339,515868,871897,581247,166597,992465,770811,547466,775719,978031,813258,636061,63307,521585,199891,238462,188775,229701,221800,206719,23040,249049,1016800,818152,516740,614062,103112,810385,851031,682390,83406,610610,168153,329058,154099,3783,660451,402604,645617,237154,414613,596676,623273,327085,641825,661886,554045,273322,1044185,905965,496356,762990,794043,36606,355242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]