SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320910 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320910 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35448,738717,418868,404449,107085,112151,888280,567099,956755,1003531,240232,340826,391049,860964,270759,961476,401041,345559,138465,963216,682354,189682,60411,765724,901264,136929,913772,303794,796709,877643,554728,671197,794067,736624,702783,791883,324931,229606,202696,799021,64360,851536,865083,155647,782906,851841,213390,42543,53697,574267,146969,297370,658727,478140,977174,641113,575569,297922,1041234,574906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000895s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]