SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001941s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540054 LIMIT 1 [ RunTime:0.000982s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540054 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293739,8379,653829,308566,320504,95534,476553,664662,771723,313562,132431,441959,296908,8665,336650,787728,354967,684381,594626,932321,185295,418267,49263,726968,1023629,908147,997522,796344,580015,856296,446865,573781,88887,649385,283067,605732,452538,885345,924542,149841,599771,102221,972317,807011,415168,121830,199455,924163,770444,716017,281059,203622,975191,824488,312373,556254,945732,727691,851303,490844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001099s ]