SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041412 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041412 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659709,138436,282878,996870,589852,563068,449707,878793,930383,517880,1006058,281824,3870,156731,952084,796231,905620,705698,592057,411647,858179,651025,139644,1032069,32141,354005,940575,557246,369780,392697,400494,703949,549408,862630,1033050,901938,916258,352881,845859,581774,657884,120560,568900,305841,574142,505829,750951,474366,614448,533833,122795,764584,675307,200967,480798,106237,780057,522839,419134,20359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]