SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104238 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104238 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581690,896903,686143,986317,627147,662824,651879,814898,202721,814008,664243,36658,686456,273228,749937,465645,361482,164818,374970,232802,445467,171499,1035278,896339,58725,956020,131801,418488,643576,472510,653967,934006,400682,490781,291302,788890,1025814,169115,978654,60193,131019,107481,947521,49455,577554,616641,464709,565444,686293,751251,129134,573630,774147,140544,570191,661074,421117,452975,236537,394210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]