SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391228 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391228 [ RunTime:0.003184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550202,30687,337166,78404,466767,217553,501148,916490,258638,462014,860673,344269,866652,200344,413808,400012,116215,926415,695562,736190,824558,641130,78128,36535,562468,842435,682450,395423,570831,156536,319025,1043921,561385,598320,945736,718345,725130,459091,754920,61755,223107,639810,293034,394104,763340,1022167,682964,550268,135292,388846,46010,60969,804595,277338,15056,849483,406295,82135,598097,887584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]