SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523836 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523836 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014553,35377,174280,657500,408493,981762,806942,35624,554771,989031,963357,19813,373693,639393,524938,368532,452708,123357,38391,688758,255108,237071,557517,680134,241589,363751,488576,978806,795538,676601,1034006,423278,72411,369656,293783,2708,993488,192160,907520,529997,219547,459336,696563,127237,211689,937278,616509,717963,839430,44371,146637,976124,63623,451335,373924,204298,725482,191358,878371,581532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]