SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425456 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425456 [ RunTime:0.003275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426084,138605,522971,269800,676956,797381,829845,273655,722290,1035868,331595,387322,568309,258815,667231,24281,921097,341973,692697,440120,594667,465247,116601,641010,738597,679056,659986,784186,94208,1043307,76936,437862,418288,715824,776088,1037027,152199,682992,525458,60646,696074,652454,421781,1016434,360904,560062,256264,1011786,634937,243448,559773,83411,457258,855031,374619,757647,709859,545653,26816,1000748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425456 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425456 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]