SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046026 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046026 [ RunTime:0.003116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170129,112569,304228,620281,802672,1036752,88489,395796,366634,369680,512147,501662,613693,726961,362526,726301,515878,92097,439711,98507,684472,884966,1011767,275943,523978,434373,298878,632532,995799,851839,975834,563909,356725,545453,888000,294228,625154,631180,135175,918164,297083,1015497,694918,141183,278292,965557,718423,655960,592590,42167,107652,312811,974381,453269,401953,370670,739042,637091,1037305,401283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000846s ]