SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267342 LIMIT 1 [ RunTime:0.003637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267342 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481253,32228,42132,137239,127090,172436,49065,959187,771289,659312,339291,1015483,775059,529220,8039,436982,295715,148322,415028,457968,436793,737446,1011842,898416,168763,885566,123513,381780,817958,456306,71323,1015702,575353,314938,892627,1008358,904556,292868,235338,222471,699023,920342,1010340,977956,362179,31392,438561,306970,803054,626215,516420,860858,671580,725313,59538,711891,1020595,304673,906601,162771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]