SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020902 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020902 [ RunTime:0.002577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121307,429856,1009650,196142,930197,162945,288879,157708,84814,643447,27917,94219,149249,123193,703581,381221,617225,491283,158071,211611,914047,896344,49361,937273,451233,583627,442558,465385,590341,312299,302186,418532,591081,178503,716961,716841,1025602,496413,554241,263938,1028829,314554,495691,455730,388388,609805,961529,744084,950613,778515,600545,45092,51999,175617,771309,620293,244893,400589,381097,1006285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]