SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502510 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502510 [ RunTime:0.001457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670865,770144,222898,531015,501729,318272,102886,348104,141476,12495,954622,161821,637232,215804,297498,551208,57066,745782,371193,452059,760175,674760,505767,821031,352104,786625,278780,738851,757074,296001,104827,187211,631020,681145,37545,296059,527497,768719,629839,880105,659444,488878,508695,574348,964735,351075,1017761,480272,47098,39550,968205,627820,795931,957506,440227,9555,700053,335002,547188,758336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]