SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807528 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807528 [ RunTime:0.004025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564850,192025,124150,251910,494195,891756,775048,985248,1039530,682301,24061,1048265,856058,1002748,814124,593484,860421,323509,954993,678084,674131,280463,15484,226825,301805,800480,208013,389074,437486,418031,18662,592850,202694,696987,704367,213860,765657,815967,466820,515617,1026083,139202,799819,812569,134569,859207,901821,771161,93569,863793,163410,938997,267201,456114,965593,733141,952185,193215,299011,855807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]