SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545253 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545253 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596794,647062,445854,316167,1004348,10562,161870,603909,1012565,79774,679790,198831,881275,28690,267324,791130,866213,104046,930437,485626,625116,907001,604467,799526,894135,873049,446699,20990,289098,318739,919532,804005,170654,427156,320729,1032116,958064,819569,922451,731881,754665,692030,331343,880963,284114,1032758,862659,143521,129378,676633,689983,737840,418722,978341,787037,941186,923009,1028030,614042,781641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001778s ]