SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330058 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330058 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258488,212449,175429,246889,192191,500437,274818,415107,58853,106691,831492,953457,898163,698760,511911,693010,849928,369070,1005571,300092,156805,155716,239621,173642,73851,786451,885109,712377,55109,1027938,416828,1045522,648647,702003,1026674,178968,785824,49662,18032,543437,452685,686355,633904,200698,50014,764127,705812,593219,444908,395248,930824,764763,728088,932735,232550,556327,163745,437224,551717,386871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]