SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539423 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539423 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602937,476,487246,545602,855310,415485,156197,143723,690723,272821,963616,165786,830814,701326,349564,813127,914112,778900,360369,725005,211852,255110,55215,270916,269104,286178,809723,86985,284347,895381,286809,550621,59437,463394,286455,696343,629100,771603,960449,753304,149425,37413,454081,1024307,304498,699295,872535,646360,424381,730252,450376,645130,245639,138952,922840,187995,42414,968656,507767,1043325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]