SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491216 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491216 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203678,767500,470774,298688,413043,76147,831085,980883,459863,930586,974842,559497,1020218,470490,591722,572187,164986,895334,486779,658555,471110,1043049,325731,769586,858760,369984,205804,861407,26199,77557,987129,887388,701520,708976,804300,961773,115041,866555,772954,786797,154479,790457,10948,597721,95393,983311,516880,638931,958109,585152,697546,340298,224152,980819,61689,162433,475521,385315,517593,249391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]