SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518510 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518510 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115028,485663,752737,720871,915353,325967,780938,628980,200213,609336,550020,988149,1007183,968654,621950,333325,119556,815349,174866,859296,91739,848517,1002442,636074,342109,453281,207458,411640,371209,631821,510318,195573,806196,378838,341544,945820,757947,804033,270048,46771,279828,508065,542939,501464,246309,242182,183160,480826,622888,174750,485887,943649,908702,360996,14091,651831,662286,745539,7098,73448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004670s ]