SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681508 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681508 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510367,975526,409406,597615,146823,796124,325221,275085,100083,483973,978140,385998,755245,743832,950410,863887,315446,490872,422355,679886,419944,921932,928882,683503,183400,331891,814095,172394,472423,540424,202811,482169,939326,71641,406059,523696,462522,412298,630687,911817,395645,264941,671069,305859,530066,818247,452902,17506,320564,191126,268184,372489,588307,624024,267474,1035257,1004946,363282,817301,287684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]