SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194882 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194882 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268582,509715,542801,843548,315888,618725,1018246,1039834,764923,1044325,684191,986501,935110,609212,1026429,840787,833982,279795,373507,712561,536103,813947,335469,984659,375476,144390,715164,808195,93322,62532,363872,360746,988926,551199,874510,14951,673030,388500,795437,986455,469101,412113,739569,171521,145590,156182,1040983,201498,259251,823528,690628,690773,596508,609011,624606,357753,948273,317643,680065,457578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]